Search Results for: "Performance Center 9mm"

select * from tb_mfg_promo.dbo.tb_search_redirect with (nolock) where kword='Performance-Center-9mm' and kword <> '' and kword is not NULL and site='sportsman'

SELECT distinct a.style_id,
 case a.style_id 
 
 when 148355 then 1 
 when 148697 then 2 
 when 290567 then 3 
 when 247269 then 4 
 when 203613 then 5 
 when 134628 then 6 
 when 151002 then 7 
 when 170303 then 8 
 when 151003 then 9 
 when 165384 then 10 
 when 297594 then 11 
 when 79472 then 12 
 when 246964 then 13 
 when 278917 then 14 
 when 203616 then 15 
 when 269851 then 16 
 when 202309 then 17 
 when 263845 then 18 
 when 269852 then 19 
 when 269850 then 20 
 when 266241 then 21 
 when 217659 then 22 
 when 247280 then 23 
 when 246992 then 24 
 when 151783 then 25 
 when 247279 then 26 
 when 264809 then 27 
 when 207354 then 28 
 when 134630 then 29 
 when 133827 then 30 
 when 189731 then 31 
 when 178870 then 32 
 when 105625 then 33 
 when 148350 then 34 
 when 192097 then 35 
 when 175907 then 36 
 when 251303 then 37 
 when 207357 then 38 
 when 251298 then 39 
 when 199529 then 40 
 when 172033 then 41 
 when 207355 then 42 
 when 251300 then 43 
 when 292239 then 44 
 when 251302 then 45 
 when 251299 then 46 
 when 269303 then 47 
 when 304769 then 48 
 when 65231 then 49 
 when 117429 then 50 
 when 134626 then 51 
 when 48920 then 52 
 when 133442 then 53 
 when 48898 then 54 
 when 48918 then 55 
 when 278911 then 56 
 when 218300 then 57 
 when 251301 then 58 
 when 248799 then 59 
 when 48916 then 60 
 when 119298 then 61 
 when 48907 then 62 
 when 48914 then 63 
 when 48897 then 64 
 when 203614 then 65 
 when 248842 then 66 
 when 218308 then 67 
 when 203612 then 68 
 when 94699 then 69 
 when 189734 then 70 
 when 203593 then 71 
 when 48904 then 72 
 when 134629 then 73 
 when 225703 then 74 
 when 307659 then 75 
 when 255630 then 76 
 when 280828 then 77 
 when 107147 then 78 
 when 48910 then 79 
 when 247276 then 80 
 when 299119 then 81 
 when 48919 then 82 
 when 48912 then 83 
 when 286628 then 84 
 when 290171 then 85 
 when 203615 then 86 
 when 207420 then 87 
 when 266667 then 88 
 when 114322 then 89 
 when 117757 then 90 
 when 97803 then 91 
 when 286307 then 92 
 when 290170 then 93 
 when 218305 then 94 
 when 132542 then 95 
 when 189732 then 96 
 when 225702 then 97 
 when 266668 then 98 
 when 247275 then 99 
 when 269004 then 100 
 when 266671 then 101 
 when 250676 then 102 
 when 151004 then 103 
 when 247271 then 104 
 when 266677 then 105 
 when 290174 then 106 
 when 249809 then 107 
 when 281769 then 108 
 when 247283 then 109 
 when 217403 then 110 
 when 270599 then 111 
 when 264449 then 112 
 when 247281 then 113 
 when 252753 then 114 
 when 123424 then 115 
 when 218306 then 116 
 when 263847 then 117 
 when 124889 then 118 
 when 170361 then 119 
 when 207415 then 120 
 when 268724 then 121 
 when 164394 then 122 
 when 207353 then 123 
 when 215565 then 124 
 when 207356 then 125 
 when 215564 then 126 
 when 207358 then 127 
 when 264059 then 128 
 when 176008 then 129 
 when 134627 then 130 
 when 149555 then 131 
 when 173255 then 132 
 when 136427 then 133 
 when 306703 then 134 
 when 254748 then 135 
 when 179496 then 136 
 when 81637 then 137 
 when 67716 then 138 
 when 203594 then 139 
 when 207422 then 140 
 when 281767 then 141 
 when 217662 then 142 
 when 291711 then 143 
 when 151005 then 144 
 when 165385 then 145 
 when 175908 then 146 
 when 48896 then 147 
 when 211580 then 148 
 when 290173 then 149 
 when 309318 then 150 
 when 207421 then 151 
 when 249902 then 152 
 when 189730 then 153 
 when 205461 then 154 
 when 247278 then 155 
 when 140013 then 156 
 when 207423 then 157 
 when 247277 then 158 
 when 217661 then 159 
 when 207437 then 160 
 when 218307 then 161 
 when 281768 then 162 
 when 290160 then 163 
 when 189733 then 164 
 when 247274 then 165 
 when 290161 then 166 
 when 290165 then 167 
 when 298199 then 168 
 when 218302 then 169 
 when 217660 then 170 
 when 218303 then 171 
 when 218301 then 172 
 when 290166 then 173 
 when 197424 then 174 
 when 198151 then 175 
 when 218304 then 176 
 when 199686 then 177 
 when 262444 then 178 
 when 247284 then 179 
 when 247286 then 180 
 when 196964 then 181 
 when 247289 then 182 
 when 247287 then 183 
 when 197425 then 184 
 when 197414 then 185 
 when 196963 then 186 
 when 262450 then 187 
 when 200664 then 188 
 when 196962 then 189 
 when 199583 then 190 
 when 199582 then 191 
 when 199689 then 192 
 when 150077 then 193 
 when 196969 then 194 
 when 196965 then 195 
 when 199585 then 196 
 when 196966 then 197 
 when 199586 then 198 
 when 199691 then 199 
 when 199688 then 200 
 when 207405 then 201 
 when 196961 then 202 
 when 199584 then 203 
 when 199692 then 204 
 when 199693 then 205 
 when 199690 then 206 
 when 287727 then 207 
 when 199694 then 208 
 when 199695 then 209 
 when 218347 then 210 
 when 264127 then 211 
 when 264128 then 212 
 when 206010 then 213 
 when 176408 then 214 
 when 248200 then 215 
 when 72317 then 216 
 when 176406 then 217 
 when 202107 then 218 
 when 248201 then 219 
 when 264461 then 220 
 when 264459 then 221 
 when 264457 then 222 
 when 192986 then 223 
 when 264458 then 224 
 when 35062 then 225 
 when 283049 then 226 
 when 134558 then 227 
 when 248199 then 228 
 when 41663 then 229 
 when 264460 then 230 
 when 35121 then 231 
 when 84386 then 232 
 when 198992 then 233 
 when 198991 then 234 
 when 201901 then 235 
 when 201462 then 236 
 when 216067 then 237 
 when 255653 then 238 
 when 214650 then 239 
 when 264465 then 240 
 when 263709 then 241 
 when 203241 then 242 
 when 141521 then 243 
 when 256084 then 244 
 when 72823 then 245 
 when 202381 then 246 
 when 23563 then 247 
 when 95525 then 248 
 when 151988 then 249 
 when 164396 then 250 
 when 164393 then 251 
 when 164395 then 252 
 when 248198 then 253 
 when 179494 then 254 
 when 151989 then 255 
 when 283444 then 256 
 when 155378 then 257 
 when 291685 then 258 
 when 298601 then 259 
 when 306696 then 260 
 when 267389 then 261 
 when 23569 then 262 
 when 267991 then 263 
 when 42267 then 264 
 when 215918 then 265 
 when 198531 then 266 
 when 201536 then 267 
 when 117637 then 268 
 when 198530 then 269 
 when 199002 then 270 
 when 201461 then 271 
 when 198990 then 272 
 when 202077 then 273 
 when 201900 then 274 
 when 249844 then 275 
 when 215919 then 276 
 when 283443 then 277 
 when 210951 then 278 
 when 306885 then 279 
 when 249846 then 280 
 when 202377 then 281 
 when 249848 then 282 
 when 275753 then 283 
 when 269841 then 284 
 when 198532 then 285 
 when 198529 then 286 
 when 202373 then 287 
 when 201456 then 288 
 when 201488 then 289 
 when 202375 then 290 
 when 201460 then 291 
 when 198989 then 292 
 when 201589 then 293 
 when 202758 then 294 
 when 267115 then 295 
 when 272491 then 296 
 when 269270 then 297 
 when 296288 then 298 
 when 198219 then 299 
 when 201458 then 300 
 when 198533 then 301 
 when 191909 then 302 
 when 113684 then 303 
 when 203242 then 304 
 when 202383 then 305 
 when 202365 then 306 
 when 202378 then 307 
 when 262452 then 308 
 when 262454 then 309 
 when 262448 then 310 
 when 296655 then 311 
 when 301845 then 312 
 when 301847 then 313 
 when 143100 then 314 
 when 155356 then 315 
 when 207047 then 316 
 when 225677 then 317 
 when 61302 then 318 
 when 247536 then 319 
 when 179630 then 320 
 when 209587 then 321 
 when 277659 then 322 
 when 266855 then 323 
 when 250832 then 324 
 when 261358 then 325 
 when 265014 then 326 
 when 268728 then 327 
 when 43620 then 328 
 when 61303 then 329 
 when 43025 then 330 
 when 213857 then 331 
 when 250127 then 332 
 when 121210 then 333 
 when 268373 then 334 
 when 254547 then 335 
 when 245026 then 336 
 when 126805 then 337 
 when 143315 then 338 
 when 272506 then 339 
 when 288346 then 340 
 when 298396 then 341 
 when 298540 then 342 
 when 55222 then 343 
 when 248551 then 344 
 when 277657 then 345 
 when 288510 then 346 
 when 225745 then 347 
 when 290182 then 348 
 when 298173 then 349 
 when 212129 then 350 
 when 213858 then 351 
 when 254313 then 352 
 when 268723 then 353 
 when 277175 then 354 
 when 211811 then 355 
 when 222406 then 356 
 when 245028 then 357 
 when 268731 then 358 
 when 245027 then 359 
 when 55482 then 360 
 when 72288 then 361 
 when 193538 then 362 
 when 192239 then 363 
 when 277658 then 364 
 when 257285 then 365 
 when 39530 then 366 
 when 269101 then 367 
 when 184311 then 368 
 when 184310 then 369 
 when 254186 then 370 
 when 298711 then 371 
 when 202302 then 372 
 when 39340 then 373 
 when 195463 then 374 
 when 249990 then 375 
 when 207700 then 376 
 when 170314 then 377 
 when 252444 then 378 
 when 73378 then 379 
 when 254223 then 380 
 when 184357 then 381 
 when 255591 then 382 
 when 228153 then 383 
 when 124789 then 384 
 when 202798 then 385 
 when 249935 then 386 
 when 125018 then 387 
 when 181487 then 388 
 when 23539 then 389 
 when 28114 then 390 
 when 248264 then 391 
 when 87808 then 392 
 when 55468 then 393 
 when 198983 then 394 
 when 291725 then 395 
 when 151558 then 396 
 when 251682 then 397 
 when 144880 then 398 
 when 248751 then 399 
 when 161825 then 400 
 when 204311 then 401 
 when 216552 then 402 
 when 249937 then 403 
 when 260841 then 404 
 when 254848 then 405 
 when 141562 then 406 
 when 267981 then 407 
 when 19181 then 408 
 when 19180 then 409 
 when 137597 then 410 
 when 216527 then 411 
 when 204442 then 412 
 when 79096 then 413 
 when 99665 then 414 
 when 169846 then 415 
 when 245695 then 416 
 when 253465 then 417 
 when 264889 then 418 
 when 248955 then 419 
 when 200029 then 420 
 when 217965 then 421 
 when 247671 then 422 
 when 263909 then 423 
 when 256020 then 424 
 when 105889 then 425 
 when 23529 then 426 
 when 205382 then 427 
 when 269967 then 428 
 when 44908 then 429 
 when 130331 then 430 
 when 211810 then 431 
 when 148141 then 432 
 when 13392 then 433 
 when 249311 then 434 
 when 248752 then 435 
 when 251863 then 436 
 when 249312 then 437 
 when 207854 then 438 
 when 199244 then 439 
 when 139955 then 440 
 when 203790 then 441 
 when 247658 then 442 
 when 232220 then 443 
 when 285501 then 444 
 when 307781 then 445 
 when 69675 then 446 
 when 136927 then 447 
 when 141800 then 448 
 when 202739 then 449 
 when 206256 then 450 
 when 248328 then 451 
 when 249754 then 452 
 when 254592 then 453 
 when 255252 then 454 
 when 255251 then 455 
 when 207424 then 456 
 when 89930 then 457 
 when 284851 then 458 
 when 304633 then 459 
 when 202511 then 460 
 when 210145 then 461 
 when 104307 then 462 
 when 181373 then 463 
 when 214647 then 464 
 when 216231 then 465 
 when 204563 then 466 
 when 55379 then 467 
 when 95969 then 468 
 when 192240 then 469 
 when 256903 then 470 
 when 264586 then 471 
 when 292979 then 472 
 when 200342 then 473 
 when 200339 then 474 
 when 153387 then 475 
 when 181482 then 476 
 when 247680 then 477 
 when 247673 then 478 
 when 247679 then 479 
 when 227233 then 480 
 when 247783 then 481 
 when 267845 then 482 
 when 267843 then 483 
 when 267844 then 484 
 when 267846 then 485 
 when 277916 then 486 
 when 277918 then 487 
 when 287937 then 488 
 when 287933 then 489 
 when 285771 then 490 
 when 289385 then 491 
 when 290483 then 492 
 when 299262 then 493 
 when 305222 then 494 
 when 309625 then 495 
 when 89241 then 496 
 when 188870 then 497 
 when 202527 then 498 
 when 285507 then 499 
 when 291754 then 500 
 when 299253 then 501 
 when 307696 then 502 
 when 110675 then 503 
 when 257287 then 504 
 when 293151 then 505 
 when 124924 then 506 
 when 206284 then 507 
 when 205195 then 508 
 when 254256 then 509 
 when 111562 then 510 
 when 202131 then 511 
 when 205643 then 512 
 when 117161 then 513 
 when 228154 then 514 
 when 228156 then 515 
 when 152910 then 516 
 when 228155 then 517 
 when 251738 then 518 
 when 255661 then 519 
 when 263549 then 520 
 when 281331 then 521 
 when 291113 then 522 
 when 293404 then 523 
 when 296548 then 524 
 when 158388 then 525 
 when 178666 then 526 
 when 89028 then 527 
 when 61175 then 528 
 when 61300 then 529 
 when 103831 then 530 
 when 164832 then 531 
 when 159424 then 532 
 when 165522 then 533 
 when 202771 then 534 
 when 254572 then 535 
 when 276723 then 536 
 when 61170 then 537 
 when 101905 then 538 
 when 168324 then 539 
 when 214611 then 540 
 when 249934 then 541 
 when 252398 then 542 
 when 257257 then 543 
 when 97871 then 544 
 when 153388 then 545 
 when 198802 then 546 
 when 197602 then 547 
 when 205379 then 548 
 when 213726 then 549 
 when 225344 then 550 
 when 171941 then 551 
 when 251295 then 552 
 when 285839 then 553 
 when 291109 then 554 
 when 285943 then 555 
 when 307890 then 556 
 when 214097 then 557 
 when 282963 then 558 
 when 41531 then 559 
 when 248659 then 560 
 when 256899 then 561 
 when 128639 then 562 
 when 110298 then 563 
 when 48944 then 564 
 when 181572 then 565 
 when 202481 then 566 
 when 202526 then 567 
 when 213299 then 568 
 when 263666 then 569 
 when 278149 then 570 
 when 145134 then 571 
 when 169480 then 572 
 when 169845 then 573 
 when 183951 then 574 
 when 13393 then 575 
 when 150211 then 576 
 when 209921 then 577 
 when 171944 then 578 
 when 213297 then 579 
 when 121174 then 580 
 when 112595 then 581 
 when 163704 then 582 
 when 218326 then 583 
 when 117818 then 584 
 when 268770 then 585 
 when 267818 then 586 
 when 269080 then 587 
 when 268413 then 588 
 when 269081 then 589 
 when 268271 then 590 
 when 280182 then 591 
 when 269451 then 592 
 when 285166 then 593 
 when 285185 then 594 
 when 285146 then 595 
 when 280843 then 596 
 when 285886 then 597 
 when 285155 then 598 
 when 285156 then 599 
 when 285187 then 600 
 when 287925 then 601 
 when 287899 then 602 
 when 291256 then 603 
 when 290584 then 604 
 when 291077 then 605 
 when 285803 then 606 
 when 299205 then 607 
 when 287013 then 608 
 when 248952 then 609 
 when 301551 then 610 
 when 307695 then 611 
 when 305568 then 612 
 when 299054 then 613 
 when 305103 then 614 
 when 309311 then 615 
 when 305507 then 616 
 when 210318 then 617 
 when 218079 then 618 
 when 285514 then 619 
 when 290551 then 620 
 when 294930 then 621 
 when 272200 then 622 
 when 202628 then 623 
 when 176403 then 624 
 when 176399 then 625 
 when 55431 then 626 
 when 55453 then 627 
 when 55480 then 628 
 when 72315 then 629 
 when 169407 then 630 
 when 55443 then 631 
 when 61169 then 632 
 when 61301 then 633 
 when 61487 then 634 
 when 179676 then 635 
 when 202738 then 636 
 when 204919 then 637 
 when 72688 then 638 
 when 204587 then 639 
 when 204312 then 640 
 when 219610 then 641 
 when 218016 then 642 
 when 159149 then 643 
 when 245350 then 644 
 when 247445 then 645 
 when 248327 then 646 
 when 250052 then 647 
 when 126694 then 648 
 when 253439 then 649 
 when 256793 then 650 
 when 277298 then 651 
 when 290187 then 652 
 when 293364 then 653 
 when 293164 then 654 
 when 250055 then 655 
 when 254118 then 656 
 when 154689 then 657 
 when 175547 then 658 
 when 175546 then 659 
 when 209840 then 660 
 when 205191 then 661 
 when 173493 then 662 
 when 251860 then 663 
 when 253108 then 664 
 when 266935 then 665 
 when 261340 then 666 
 when 295107 then 667 
 when 301285 then 668 
 when 251862 then 669 
 when 193439 then 670 
 when 122327 then 671 
 when 169265 then 672 
 when 208654 then 673 
 when 225270 then 674 
 when 248956 then 675 
 when 252346 then 676 
 when 122517 then 677 
 when 245849 then 678 
 when 151676 then 679 
 when 272916 then 680 
 when 248661 then 681 
 when 256900 then 682 
 when 148326 then 683 
 when 156356 then 684 
 when 157927 then 685 
 when 171961 then 686 
 when 169843 then 687 
 when 179169 then 688 
 when 169875 then 689 
 when 193227 then 690 
 when 202808 then 691 
 when 61374 then 692 
 when 247676 then 693 
 when 247826 then 694 
 when 246760 then 695 
 when 250445 then 696 
 when 250165 then 697 
 when 67720 then 698 
 when 256068 then 699 
 when 252148 then 700 
 when 97196 then 701 
 when 267774 then 702 
 when 263957 then 703 
 when 267841 then 704 
 when 268265 then 705 
 when 263956 then 706 
 when 267419 then 707 
 when 267838 then 708 
 when 279963 then 709 
 when 281657 then 710 
 when 277909 then 711 
 when 285840 then 712 
 when 280845 then 713 
 when 280830 then 714 
 when 281736 then 715 
 when 285347 then 716 
 when 287930 then 717 
 when 285508 then 718 
 when 287910 then 719 
 when 285522 then 720 
 when 285346 then 721 
 when 285794 then 722 
 when 296575 then 723 
 when 289745 then 724 
 when 294876 then 725 
 when 292997 then 726 
 when 298993 then 727 
 when 298986 then 728 
 when 294960 then 729 
 when 205679 then 730 
 when 277907 then 731 
 when 281416 then 732 
 when 285379 then 733 
 when 285428 then 734 
 when 68634 then 735 
 when 99095 then 736 
 when 75668 then 737 
 when 24386 then 738 
 when 191512 then 739 
 when 28308 then 740 
 when 182367 then 741 
 when 164345 then 742 
 when 111463 then 743 
 when 151211 then 744 
 when 161406 then 745 
 when 115101 then 746 
 when 202530 then 747 
 when 151650 then 748 
 when 205603 then 749 
 when 126572 then 750 
 when 252448 then 751 
 when 256646 then 752 
 when 151774 then 753 
 when 48981 then 754 
 when 181484 then 755 
 when 198514 then 756 
 when 264887 then 757 
 when 255290 then 758 
 when 61173 then 759 
 when 61172 then 760 
 when 72689 then 761 
 when 204062 then 762 
 when 201196 then 763 
 when 250053 then 764 
 when 126762 then 765 
 when 185604 then 766 
 when 193652 then 767 
 when 254571 then 768 
 when 256417 then 769 
 when 266745 then 770 
 when 298172 then 771 
 when 291607 then 772 
 when 204061 then 773 
 when 250485 then 774 
 when 130488 then 775 
 when 48945 then 776 
 when 65289 then 777 
 when 28043 then 778 
 when 172953 then 779 
 when 196049 then 780 
 when 195748 then 781 
 when 196379 then 782 
 when 204867 then 783 
 when 242412 then 784 
 when 221035 then 785 
 when 215235 then 786 
 when 245694 then 787 
 when 253303 then 788 
 when 268284 then 789 
 when 266766 then 790 
 when 268239 then 791 
 when 280181 then 792 
 when 277878 then 793 
 when 276782 then 794 
 when 288151 then 795 
 when 277379 then 796 
 when 288033 then 797 
 when 285423 then 798 
 when 285143 then 799 
 when 285510 then 800 
 when 288098 then 801 
 when 290594 then 802 
 when 285779 then 803 
 when 293059 then 804 
 when 289744 then 805 
 when 297394 then 806 
 when 290843 then 807 
 when 305107 then 808 
 when 294899 then 809 
 when 301150 then 810 
 when 309610 then 811 
 when 197599 then 812 
 when 245427 then 813 
 when 267886 then 814 
 when 285493 then 815 
 when 289770 then 816 
 when 290536 then 817 
 when 294871 then 818 
 when 220974 then 819 
 when 220976 then 820 
 when 254377 then 821 
 when 255615 then 822 
 when 261337 then 823 
 when 264364 then 824 
 when 286588 then 825 
 when 295109 then 826 
 when 159528 then 827 
 when 220975 then 828 
 when 209475 then 829 
 when 24385 then 830 
 when 47886 then 831 
 when 24387 then 832 
 when 221038 then 833 
 when 44726 then 834 
 when 13397 then 835 
 when 13396 then 836 
 when 210666 then 837 
 when 217333 then 838 
 when 217253 then 839 
 when 228588 then 840 
 when 223087 then 841 
 when 242415 then 842 
 when 225339 then 843 
 when 249115 then 844 
 when 181483 then 845 
 when 49007 then 846 
 when 170677 then 847 
 when 252303 then 848 
 when 72185 then 849 
 when 253075 then 850 
 when 267831 then 851 
 when 267412 then 852 
 when 267825 then 853 
 when 267832 then 854 
 when 267839 then 855 
 when 267821 then 856 
 when 267819 then 857 
 when 267817 then 858 
 when 267829 then 859 
 when 267820 then 860 
 when 268778 then 861 
 when 267828 then 862 
 when 267824 then 863 
 when 267814 then 864 
 when 267826 then 865 
 when 267816 then 866 
 when 267835 then 867 
 when 278382 then 868 
 when 272203 then 869 
 when 286308 then 870 
 when 281730 then 871 
 when 279984 then 872 
 when 285855 then 873 
 when 281159 then 874 
 when 285506 then 875 
 when 285783 then 876 
 when 285516 then 877 
 when 285819 then 878 
 when 285426 then 879 
 when 291112 then 880 
 when 290565 then 881 
 when 290502 then 882 
 when 290506 then 883 
 when 290497 then 884 
 when 297379 then 885 
 when 291255 then 886 
 when 300594 then 887 
 when 294877 then 888 
 when 297414 then 889 
 when 293003 then 890 
 when 300610 then 891 
 when 307777 then 892 
 when 299254 then 893 
 when 303655 then 894 
 when 202158 then 895 
 when 245865 then 896 
 when 168856 then 897 
 when 267836 then 898 
 when 267833 then 899 
 when 267882 then 900 
 when 280390 then 901 
 when 285412 then 902 
 when 285415 then 903 
 when 290010 then 904 
 when 291254 then 905 
 when 297373 then 906 
 when 307702 then 907 
 when 104308 then 908 
 when 181375 then 909 
 when 205846 then 910 
 when 216118 then 911 
 when 55466 then 912 
 when 176404 then 913 
 when 271329 then 914 
 when 157974 then 915 
 when 189618 then 916 
 when 189306 then 917 
 when 188882 then 918 
 when 189066 then 919 
 when 190016 then 920 
 when 205601 then 921 
 when 216708 then 922 
 when 246132 then 923 
 when 252445 then 924 
 when 252447 then 925 
 when 266130 then 926 
 when 77223 then 927 
 when 167824 then 928 
 when 267976 then 929 
 when 279112 then 930 
 when 24534 then 931 
 when 200047 then 932 
 when 217978 then 933 
 when 251118 then 934 
 when 264440 then 935 
 when 76867 then 936 
 when 285206 then 937 
 when 264425 then 938 
 when 61176 then 939 
 when 19432 then 940 
 when 158312 then 941 
 when 209594 then 942 
 when 215040 then 943 
 when 221175 then 944 
 when 252622 then 945 
 when 262137 then 946 
 when 252759 then 947 
 when 19430 then 948 
 when 290167 then 949 
 when 256902 then 950 
 when 183979 then 951 
 when 205193 then 952 
 when 261338 then 953 
 when 263787 then 954 
 when 277843 then 955 
 when 292848 then 956 
 when 289114 then 957 
 when 292850 then 958 
 when 292827 then 959 
 when 292853 then 960 
 when 253325 then 961 
 when 262405 then 962 
 when 271871 then 963 
 when 292849 then 964 
 when 103550 then 965 
 when 125792 then 966 
 when 28018 then 967 
 when 142968 then 968 
 when 163874 then 969 
 when 85564 then 970 
 when 108216 then 971 
 when 209923 then 972 
 when 220135 then 973 
 when 222563 then 974 
 when 228613 then 975 
 when 225692 then 976 
 when 118777 then 977 
 when 158335 then 978 
 when 242398 then 979 
 when 228599 then 980 
 when 249308 then 981 
 when 247363 then 982 
 when 167958 then 983 
 when 267797 then 984 
 when 267795 then 985 
 when 280844 then 986 
 when 271473 then 987 
 when 283972 then 988 
 when 281365 then 989 
 when 281746 then 990 
 when 281377 then 991 
 when 288115 then 992 
 when 281296 then 993 
 when 285873 then 994 
 when 287922 then 995 
 when 207386 then 996 
 when 290660 then 997 
 when 285937 then 998 
 when 294897 then 999 
 when 292986 then 1000 
 else 1000 
 
 end as ranking,
 
 
 
 max(a.non_invt) as non_invt,sum(qoh + qc) as available,max(a.dept) as dept,max(a.brand) as brand,max(a.of3) as of3,case when sum(qoh + qc) > 0 then 1 else 0 end as instock
 FROM web_all_products a WITH (NOLOCK)
 INNER JOIN dbo.tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
 INNER JOIN dbo.tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id and c.store_id=10)
 INNER JOIN dbo.tb_styles_web_taxonomy d WITH (NOLOCK) ON (a.style_id = d.style)
 INNER JOIN dbo.tb_styles qq WITH (NOLOCK) ON (qq.style_id = a.style_id)
 where a.style_id in (148355,148697,290567,247269,203613,134628,151002,170303,151003,165384,297594,79472,246964,278917,203616,269851,202309,263845,269852,269850,266241,217659,247280,246992,151783,247279,264809,207354,134630,133827,189731,178870,105625,148350,192097,175907,251303,207357,251298,199529,172033,207355,251300,292239,251302,251299,269303,304769,65231,117429,134626,48920,133442,48898,48918,278911,218300,251301,248799,48916,119298,48907,48914,48897,203614,248842,218308,203612,94699,189734,203593,48904,134629,225703,307659,255630,280828,107147,48910,247276,299119,48919,48912,286628,290171,203615,207420,266667,114322,117757,97803,286307,290170,218305,132542,189732,225702,266668,247275,269004,266671,250676,151004,247271,266677,290174,249809,281769,247283,217403,270599,264449,247281,252753,123424,218306,263847,124889,170361,207415,268724,164394,207353,215565,207356,215564,207358,264059,176008,134627,149555,173255,136427,306703,254748,179496,81637,67716,203594,207422,281767,217662,291711,151005,165385,175908,48896,211580,290173,309318,207421,249902,189730,205461,247278,140013,207423,247277,217661,207437,218307,281768,290160,189733,247274,290161,290165,298199,218302,217660,218303,218301,290166,197424,198151,218304,199686,262444,247284,247286,196964,247289,247287,197425,197414,196963,262450,200664,196962,199583,199582,199689,150077,196969,196965,199585,196966,199586,199691,199688,207405,196961,199584,199692,199693,199690,287727,199694,199695,218347,264127,264128,206010,176408,248200,72317,176406,202107,248201,264461,264459,264457,192986,264458,35062,283049,134558,248199,41663,264460,35121,84386,198992,198991,201901,201462,216067,255653,214650,264465,263709,203241,141521,256084,72823,202381,23563,95525,151988,164396,164393,164395,248198,179494,151989,283444,155378,291685,298601,306696,267389,23569,267991,42267,215918,198531,201536,117637,198530,199002,201461,198990,202077,201900,249844,215919,283443,210951,306885,249846,202377,249848,275753,269841,198532,198529,202373,201456,201488,202375,201460,198989,201589,202758,267115,272491,269270,296288,198219,201458,198533,191909,113684,203242,202383,202365,202378,262452,262454,262448,296655,301845,301847,143100,155356,207047,225677,61302,247536,179630,209587,277659,266855,250832,261358,265014,268728,43620,61303,43025,213857,250127,121210,268373,254547,245026,126805,143315,272506,288346,298396,298540,55222,248551,277657,288510,225745,290182,298173,212129,213858,254313,268723,277175,211811,222406,245028,268731,245027,55482,72288,193538,192239,277658,257285,39530,269101,184311,184310,254186,298711,202302,39340,195463,249990,207700,170314,252444,73378,254223,184357,255591,228153,124789,202798,249935,125018,181487,23539,28114,248264,87808,55468,198983,291725,151558,251682,144880,248751,161825,204311,216552,249937,260841,254848,141562,267981,19181,19180,137597,216527,204442,79096,99665,169846,245695,253465,264889,248955,200029,217965,247671,263909,256020,105889,23529,205382,269967,44908,130331,211810,148141,13392,249311,248752,251863,249312,207854,199244,139955,203790,247658,232220,285501,307781,69675,136927,141800,202739,206256,248328,249754,254592,255252,255251,207424,89930,284851,304633,202511,210145,104307,181373,214647,216231,204563,55379,95969,192240,256903,264586,292979,200342,200339,153387,181482,247680,247673,247679,227233,247783,267845,267843,267844,267846,277916,277918,287937,287933,285771,289385,290483,299262,305222,309625,89241,188870,202527,285507,291754,299253,307696,110675,257287,293151,124924,206284,205195,254256,111562,202131,205643,117161,228154,228156,152910,228155,251738,255661,263549,281331,291113,293404,296548,158388,178666,89028,61175,61300,103831,164832,159424,165522,202771,254572,276723,61170,101905,168324,214611,249934,252398,257257,97871,153388,198802,197602,205379,213726,225344,171941,251295,285839,291109,285943,307890,214097,282963,41531,248659,256899,128639,110298,48944,181572,202481,202526,213299,263666,278149,145134,169480,169845,183951,13393,150211,209921,171944,213297,121174,112595,163704,218326,117818,268770,267818,269080,268413,269081,268271,280182,269451,285166,285185,285146,280843,285886,285155,285156,285187,287925,287899,291256,290584,291077,285803,299205,287013,248952,301551,307695,305568,299054,305103,309311,305507,210318,218079,285514,290551,294930,272200,202628,176403,176399,55431,55453,55480,72315,169407,55443,61169,61301,61487,179676,202738,204919,72688,204587,204312,219610,218016,159149,245350,247445,248327,250052,126694,253439,256793,277298,290187,293364,293164,250055,254118,154689,175547,175546,209840,205191,173493,251860,253108,266935,261340,295107,301285,251862,193439,122327,169265,208654,225270,248956,252346,122517,245849,151676,272916,248661,256900,148326,156356,157927,171961,169843,179169,169875,193227,202808,61374,247676,247826,246760,250445,250165,67720,256068,252148,97196,267774,263957,267841,268265,263956,267419,267838,279963,281657,277909,285840,280845,280830,281736,285347,287930,285508,287910,285522,285346,285794,296575,289745,294876,292997,298993,298986,294960,205679,277907,281416,285379,285428,68634,99095,75668,24386,191512,28308,182367,164345,111463,151211,161406,115101,202530,151650,205603,126572,252448,256646,151774,48981,181484,198514,264887,255290,61173,61172,72689,204062,201196,250053,126762,185604,193652,254571,256417,266745,298172,291607,204061,250485,130488,48945,65289,28043,172953,196049,195748,196379,204867,242412,221035,215235,245694,253303,268284,266766,268239,280181,277878,276782,288151,277379,288033,285423,285143,285510,288098,290594,285779,293059,289744,297394,290843,305107,294899,301150,309610,197599,245427,267886,285493,289770,290536,294871,220974,220976,254377,255615,261337,264364,286588,295109,159528,220975,209475,24385,47886,24387,221038,44726,13397,13396,210666,217333,217253,228588,223087,242415,225339,249115,181483,49007,170677,252303,72185,253075,267831,267412,267825,267832,267839,267821,267819,267817,267829,267820,268778,267828,267824,267814,267826,267816,267835,278382,272203,286308,281730,279984,285855,281159,285506,285783,285516,285819,285426,291112,290565,290502,290506,290497,297379,291255,300594,294877,297414,293003,300610,307777,299254,303655,202158,245865,168856,267836,267833,267882,280390,285412,285415,290010,291254,297373,307702,104308,181375,205846,216118,55466,176404,271329,157974,189618,189306,188882,189066,190016,205601,216708,246132,252445,252447,266130,77223,167824,267976,279112,24534,200047,217978,251118,264440,76867,285206,264425,61176,19432,158312,209594,215040,221175,252622,262137,252759,19430,290167,256902,183979,205193,261338,263787,277843,292848,289114,292850,292827,292853,253325,262405,271871,292849,103550,125792,28018,142968,163874,85564,108216,209923,220135,222563,228613,225692,118777,158335,242398,228599,249308,247363,167958,267797,267795,280844,271473,283972,281365,281746,281377,288115,281296,285873,287922,207386,290660,285937,294897,292986)
 
 
  and ltrim(rtrim(lower(a.brand))) = 'smith & wesson'
 
	and a.of3='44 MAGNUM'
	
 group by a.style_id 
  order by  instock desc, ranking asc

select distinct dept from mysearch where dept <> 'EMPTY'
  order by dept asc

select distinct brand from mysearch
  order by brand asc

select distinct of3 from mysearch
  order by of3 asc

Application Variables:
acceptorid=011668467
accountid=1027380
accounttoken=64BB6980FDEAF842266AC866F250CA9877FF24AE92795FB9BE490EAF527645FC4E54DC01
adminurl=https://www.sportsmansoutdoorsuperstore.com/web_admin/products/menu.cfm?style_id=
applicationname=SOS
bannerurl=https://www.sportsmansoutdoorsuperstore.com/images/banners/
ccprocessor=VANTIV
checkinventory=Struct (3)
companyname=Vance Outdoors
credova=Struct (5)
ds=celerantsql
enter_inscription=OFF
feedsdir=E:\inetpub\feeds\
forumemail=info@sportsmansoutdoorsuperstore.com
forumtitle=Sportsmans Outdoor Superstore
giftcardimgpath=file:///C:/websites/images/
giftcardpdfpath=E:\websites\giftcardPDF\
googlefeedproducttype=
homeurl=https://www.sportsmansoutdoorsuperstore.com/
hostedpagelink=https://transaction.hostedpayments.com/
iconurl=https://www.sportsmansoutdoorsuperstore.com/images/icons/
imagedir=E:\inetpub\images\
logdir=E:\inetpub\logs
metadesc=
metatags=
mydomain=https://www.sportsmansoutdoorsuperstore.com/
pagetitle=
picurl=https://www.sportsmansoutdoorsuperstore.com/images/
prodimgdir=E:\inetpub\prodimages\
prodimgurl=https://www.sportsmansoutdoorsuperstore.com/prodimages/
qoh_store=10
safety_stock=0
salesemail=sales@sportsmansoutdoorsuperstore.com
secureurl=https://www.sportsmansoutdoorsuperstore.com/
site=sportsman
tempmailport=25
tempmailserver=127.0.0.1
tokenurl=https://services.elementexpress.com/express.asmx
use_multi_buy=OFF
vantivurl=https://transaction.elementexpress.com/express.asmx
webadminurl=https://www.sportsmansoutdoorsuperstore.com/web_admin/
websitename=Sportsmans Outdoor Superstore

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=E:\inetpub\wwwroot\search.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=
HTTP_COOKIE=fikker-2ITi-jkXI=4enQXwhGlJjmPkfWL9j3di8QM5h9hgJJ; PHPSESSID=54d44eb5f2182befb97a335e2f6d144b; fikker-KEPi-Z7Xa=BsBSbwRLNOhAxs6UKNM9KWTshGBARUhu
HTTP_HOST=www.sportsmansoutdoorsuperstore.com
HTTP_REFERER=
HTTP_URL=/search.cfm/kword/Performance-Center-9mm/of3/44-magnum/brand/smith%20and%20wesson
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=10.200.30.6
PATH_INFO=/kword/Performance-Center-9mm/of3/44-magnum/brand/smith and wesson
PATH_TRANSLATED=E:\inetpub\wwwroot\search.cfm
QUERY_STRING=
REMOTE_ADDR=10.200.2.4
REMOTE_HOST=10.200.2.4
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/search.cfm
SERVER_NAME=www.sportsmansoutdoorsuperstore.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=

Client Variables:
cfid=12076
cftoken=2ff62c93eec686f4-EA14D269-B1C0-BB26-2EB7324ADCD36E6C
hitcount=1
lastvisit={ts '2024-05-20 15:09:18'}
timecreated={ts '2024-05-20 15:09:18'}
urltoken=CFID=12076&CFTOKEN=2ff62c93eec686f4-EA14D269-B1C0-BB26-2EB7324ADCD36E6C

Cookie Variables:
CFID=12076
CFTOKEN=2ff62c93eec686f4-EA14D269-B1C0-BB26-2EB7324ADCD36E6C
CUSTOMER_ID=
EMAIL=
FIRST_NAME=
LAST_NAME=
PASSWORD=
PHPSESSID=54d44eb5f2182befb97a335e2f6d144b
USERNAME=
fikker-2ITi-jkXI=4enQXwhGlJjmPkfWL9j3di8QM5h9hgJJ
fikker-KEPi-Z7Xa=BsBSbwRLNOhAxs6UKNM9KWTshGBARUhu

Form Fields:
KWORD=Performance-Center-9mm
RETURN_TO_PAGE=null

Request Parameters:
samesite_value=

Server Variables:
coldfusion=Struct (10)
os=Struct (5)
system=Struct (2)

Session Variables:
cfid=12076
cftoken=2ff62c93eec686f4-EA14D269-B1C0-BB26-2EB7324ADCD36E6C
cs=/index.cfm
displaycount=18
employeeloggedin=N
fflnote=
firearm_agreement=NO
imgarray=Array (0)
memberloggedin=N
pickupstore=10
prodtype=none
selected_ffl=NO
sessionid=SOS_12076_2ff62c93eec686f4-EA14D269-B1C0-BB26-2EB7324ADCD36E6C
strarray=Array (0)
urltoken=CFID=12076&CFTOKEN=2ff62c93eec686f4-EA14D269-B1C0-BB26-2EB7324ADCD36E6C

URL Parameters:
CLEARANCE=
DEPT=
NAV_CHOOSER=
OF1=
OF10=
OF2=
OF4=
OF5=
OF6=
ORDER_BY=
PRODTYPE=none
RETURN_TO_PAGE=null
SECTION=
SPORTSMAN=
SUBTYP_1=
SUBTYP_2=
SUBTYP_3=
TYP=
WHATSNEW=
brand=smith and wesson
kword=Performance-Center-9mm
of3=44-magnum